September 5, 2017, update for Office 2016 (KB3203478)

This article describes update 3203478 for Microsoft Office 2016 that was released on September 5, 2017. This update has a prerequisite.

Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home. (How to determine?)

This update fixes the following issues:

• The changes to an existing PowerPivot data provider cannot be committed.
• When you upgrade the data model in a workbook that's opened from SharePoint, you receive an error message that resembles the following:

We couldn't load the Data Model. This may be because the Data Model in this workbook is damaged. PowerPivot is unable to load the Data Model.

• You cannot load tables in PowerPivot window and receive the following error message if you resize the PowerPivot window from a larger display screen to a smaller display screen:

Unable to load the tables in the PowerPivot window.

• When you try to create a new Pivot Table from the PowerPivot window, you receive the following error message:

Exception has been thrown by the target of an invocation

• After you change the size of the PowerPivot windows, the current selection is replaced with table name if semi-select mode is enabled.
• When you try to delete a sheet after you click on Add to Data Model in PowerPivot tab, Excel 2016 freezes and you receive the following error message: 

Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

Exception has been thrown by the target of an invocation.

• After you delete the data connection and then undo the operation, the PowerPivot add-in and Excel 2016 stop working.

Note To fix these issues, you also have to install this update 3203478 together with September 5, 2017, update for Office 2016 (KB3203482). 

Microsoft Update

Use Microsoft Update to automatically download and install the update.

Download Center

This update is also available for manual download and installation from the Microsoft Download Center.

• Download update KB3203478 for 32-bit version of Office 2016
• Download update KB3203478 for 64-bit version of Office 2016

If you're not sure which platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files.

Prerequisites

To apply this update, you must have Microsoft Office 2016 installed.

Restart information

You may have to restart the computer after you install this update.

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:

1. Start an Office 2016 application.
2. On the File menu, select Account.
3. For Office 2016 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.

Office 2016 Click-to-Run installation	MSI-based Office 2016

How to uninstall this update

Windows 10

1. Go to Start, enter View Installed Updates in the Search Windows box, and then press Enter.
2. In the list of updates, locate and select KB3203478, and then select Uninstall.

Windows 8 and Windows 8.1

1. Swipe in from the right edge of the screen, and then select Search. If you're using a mouse, point to the lower-right corner of the screen, and then select Search.
2. Enter windows update, select Windows Update, and then select Installed Updates.
3. In the list of updates, locate and select KB3203478, and then select Uninstall.

Windows 7

1. Go to Start, enter Run, and then select Run.
2. Enter Appwiz.cpl, and then select OK.
3. Select View installed updates.
4. In the list of updates, locate and select KB3203478, and then select Uninstall.

Learn about the standard terminology that's used to describe Microsoft software updates.

The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all versions of Office.

The English (United States) version of this software update installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.

x64

x86